{"text_format":"2","workbook":"xlsx","n_sheets":5,"sheets":["User Guide - Breeding","Breeding Herd","Gilt Rearing","Feeding Curve","Calculations"],"not_rendered":{"charts":1,"images":0,"macros":1,"external_links":0,"defined_names":0,"comments":3,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"User Guide - Breeding","index":0,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Breeding Herd","index":1,"n_rows":67,"n_cols":9,"rows_kept":67,"cut":false,"hidden":false,"merged":[[0,2,0,19],[1,2,1,19],[57,6,57,7],[2,2,2,19],[4,2,4,19],[6,13,6,19],[5,13,5,19]]}
[null,null,"Breeding Herd Calculator "]
[null,null,"Purpose – To calculate the cost of producing a weaned pig and margin per weaned pig sold  "]
[null,null,"Target user – Suitable for Breeders and Breeder- Nursery / Feeder producers"]
[]
[null,null,"How to use the calculator"]
[null,null,"The yellow boxes require your data"]
[null,null,"The blue boxes are outcomes calculated from your data"]
[]
[]
[null,null,"Herd size (served gilts+sows)",null,740,null,"Cost of production (£/piglet weaned)"]
[]
[null,null,"Unserved gilts",null,{"$f":"'Gilt Rearing'!D13","v":0}]
[]
[null,null,"Replacement rate (%)",null,55,null,"Replacement gilt rearing",null,{"$f":"Calculations!B59","v":1.6859416233671856}]
[]
[{"$nulls":6},"Income from cull sales ",null,{"$f":"Calculations!$B$64","v":2.1572096650090828}]
[]
[null,null,"Total annual AI costs (£)",null,13472,null,"Net Cost of replacement gilt rearing",null,{"$f":"I14-I16","v":-0.47126804164189728}]
[{"$nulls":6},"Feed"]
[null,null,"Sow Mortality (%)",null,3,null,"Sow",null,{"$f":"Calculations!B26/'Breeding Herd'!E50","v":9.1796559370287891}]
[]
[null,null,"Ave cull sow income ( £ )",null,130,null,"Creep",null,{"$f":"(E65*E34)/E50","v":0.15567836849069822}]
[]
[null,null,"Total annual cull sales (£)",null,{"$f":"(Calculations!B34-'Gilt Rearing'!D68)","v":46348.346000000005}]
[{"$nulls":6},"Other costs (£/piglet weaned)"]
[null,null,"Feed costs",null,null,null,"Total annual AI costs",null,{"$f":"E18/Calculations!B9","v":0.6270327015985071}]
[]
[null,null,"Dry sow diet (£/t)",null,175,null,"Veterinary & Med",null,2.2000000000000002]
[]
[null,null,"Lactating sow diet (£/t)",null,220,null,"Transport",null,0.54]
[]
[null,null,"Rebreeder diet (£/t)",null,200,null,"Electricity & Gas",null,1.1000000000000001]
[]
[null,null,"Creep feed (£/t)",null,1000,null,"Water",null,0.37]
[]
[{"$nulls":6},"Straw & bedding",null,0.8]
[]
[null,null,"Breeding herd",null,null,null,"Other variable costs",null,0.5]
[]
[null,null,"Litter per sow year",null,2.2599999999999998,null,"Labour (including family)",null,4.5]
[]
[null,null,"Litter size born alive",null,14.5,null,"Building depreciation",null,4.22]
[]
[null,null,"Pre-weaning mortality (%)",null,11.4,null,"Building repairs & maintenance",null,0.1]
[]
[null,null,"Weaning age (days)",null,26,null,"Equipment depreciation",null,0.48]
[]
[{"$nulls":6},"Equipment repairs & maintenance",null,0.05]
[]
[null,null,"Pigs weaned per sow year",null,{"$f":"(E40*E42)-((E40*E42)*E44/100)","v":29.034219999999998},null,"Other fixed costs",null,1.1200000000000001]
[]
[{"$nulls":6},"Total cost less Gilt Rearing costs",null,{"$f":"Calculations!B46","v":15.98}]
[null,null,"Feed Use (per sow)"]
[null,null,"Dry sow diet (kg/day)",null,2.7,null,"Total Costs (£/sow year)",null,{"$f":"I56*E50","v":739.53349100540527}]
[]
[null,null,"Lactating sow diet (kg/day)",null,8.25,null,"Total Costs (£/piglet weaned)",null,{"$f":"SUM(I18:I26)+I52","v":25.471098965476095}]
[]
[null,null,"Weaning to service (kg/day)",null,4,null,"Sale value of piglet weaned (£/piglet weaned)",null,35]
[]
[null,null,"Creep feed (kg/litter)",null,2]
[{"$nulls":6},"Non-productive days per sow year",null,{"$f":"Calculations!B20","v":46.340000000000032}]
[]
[null,null,"Sow feed usage (t/sow year)",null,{"$f":"Calculations!B24","v":1.3718600000000001},null,"Non-productive days per litter",null,{"$f":"I61/E40","v":20.504424778761077}]
[]
[null,null,"Creep feed usage (t/sow year)",null,{"$f":"E40*E60/1000","v":4.5199999999999997E-3}]
[]
[null,null,"Sow feed cost (£/sow year)",null,{"$f":"Calculations!B26","v":266.52414999999996},null,"Net margin (£/piglet sold)",null,{"$f":"(I58-I56)","v":9.5289010345239049}]

{"sheet":"Gilt Rearing","index":2,"n_rows":68,"n_cols":15,"rows_kept":68,"cut":false,"hidden":false,"merged":[[32,7,32,8],[26,2,26,10],[6,13,6,19],[0,2,0,19],[1,2,1,19],[2,2,2,19],[4,2,4,19],[5,13,5,19]]}
[null,null,"Gilt Rearing Calculator "]
[null,null,"Purpose – To calculate the cost of producing a gilt"]
[null,null,"Target user – Suitable for Breeders and Breeder- Nursery / Feeder producers"]
[]
[null,null,"How to use the calculator"]
[null,null,"The yellow boxes require your data"]
[null,null,"The blue boxes are outcomes calculated from your data"]
[]
[]
[]
[null,null,"Number of replacement gilts per year",{"$f":"Calculations!B39","v":407}]
[]
[null,null,"Gilts on farm ",{"$f":"(D11*Calculations!B56)/365","v":0}]
[]
[null,null,"Gilts culled (%)",{"$f":"SUM(M36:M38)","v":0}]
[]
[null,null,"Maiden gilt mortality (%)",{"$f":"SUM(O36:O38)","v":0}]
[]
[null,null,"Rearing cost of gilt at entry (£/gilt)",64]
[]
[null,null,"Genetic premium per gilt (£)",25]
[]
[null,null,"Weight at entry (kg)",60]
[]
[null,null,"Weight at first service (kg)",145]
[]
[null,null,"Feed cost and feeding plan (Entry to First Service)"]
[]
[null,null,"To clear values press the red button"]
[]
[null,null,"Number of rearing stages",3]
[]
[{"$nulls":7},"Gilt Weight (kg)",null,null,"Feed allowance"]
[null,null,null,"Feed costs (£/t)",null,"Days",null,"IN","OUT",null,"Daily per gilt (kg)",null,"Gilts culled (%)",null,"Gilt Mortality (%)"]
[]
[null,null,"Stage 1",{"$nulls":4},60]
[null,null,{"$f":"IF(D31>1,\"Stage 2\",\"\")","v":"Stage 2"}]
[null,null,{"$f":"IF(D31>2,\"Stage 3\",\"\")","v":"Stage 3"}]
[]
[]
[null,null,"Total annual gilt rearing costs","£"]
[]
[null,null,"Gilt Purchases",{"$f":"D11*(D19+D21)","v":36223}]
[]
[null,null,"Feed ",{"$f":"Calculations!I55","v":0}]
[]
[null,null,"Total fixed and other variable costs",{"$f":"Calculations!C45","v":0}]
[]
[null,null,"Total",{"$f":"SUM(D43:D47)","v":36223}]
[]
[null,null,"FYI"]
[null,null,"Synchronising costs (£/gilt)",10]
[]
[null,null,"Total Annual Synchronising Costs (£)",{"$f":"D52*Calculations!B35","v":4070}]
[]
[null,null,"Total Annual Genetic Costs (£)",{"$f":"D21*D11","v":10175}]
[]
[]
[null,null,"CULL SOW costs"]
[null,null,"Ave holding days cull sows",14]
[]
[null,null,"Number cull sows sold",{"$f":"Calculations!B33","v":394.79}]
[]
[null,null,"Total annual cull sow holding days",{"$f":"D62*D60","v":5527.06}]
[]
[null,null,"Cost per day feed + straw + labour+housing ( £ )",0.9]
[]
[null,null,"Cost for holding cull sows",{"$f":"D64*D66","v":4974.3540000000003}]

{"sheet":"Feeding Curve","index":3,"n_rows":53,"n_cols":4,"rows_kept":53,"cut":false,"hidden":false,"merged":[[5,1,5,2],[6,1,6,2],[7,1,7,2],[1,1,1,18],[2,12,2,18],[3,12,3,18],[2,1,2,5],[3,1,3,5]]}
[null,"Feeding Curve"]
[null,"How to use the calculator"]
[null,"The yellow boxes require your data"]
[null,"The blue boxes are outcomes calculated from your data"]
[]
[null,"Number of days before due date sow moved to farrowing house",null,4]
[null,"Average litter size (born alive)",null,{"$f":"'Breeding Herd'!E42","v":14.5}]
[null,"Average days in lactation",null,35]
[]
[null,"Day","Feed allowance (kg)"]
[null,{"$f":"IF(Calculations!R5<'Feeding Curve'!$D$8+1,Calculations!R5,\"\")","v":-4},2.5]
[null,{"$f":"IF(Calculations!R6<'Feeding Curve'!$D$8+1,Calculations!R6,\"\")","v":-3},2.5]
[null,{"$f":"IF(Calculations!R7<'Feeding Curve'!$D$8+1,Calculations!R7,\"\")","v":-2},2.5]
[null,{"$f":"IF(Calculations!R8<'Feeding Curve'!$D$8+1,Calculations!R8,\"\")","v":-1},2.5]
[null,{"$f":"IF(Calculations!R9<'Feeding Curve'!$D$8+1,Calculations!R9,\"\")","v":0},2.5]
[null,{"$f":"IF(Calculations!R10<'Feeding Curve'!$D$8+1,Calculations!R10,\"\")","v":1},3]
[null,{"$f":"IF(Calculations!R11<'Feeding Curve'!$D$8+1,Calculations!R11,\"\")","v":2},3.5]
[null,{"$f":"IF(Calculations!R12<'Feeding Curve'!$D$8+1,Calculations!R12,\"\")","v":3},4]
[null,{"$f":"IF(Calculations!R13<'Feeding Curve'!$D$8+1,Calculations!R13,\"\")","v":4},4.5]
[null,{"$f":"IF(Calculations!R14<'Feeding Curve'!$D$8+1,Calculations!R14,\"\")","v":5},5]
[null,{"$f":"IF(Calculations!R15<'Feeding Curve'!$D$8+1,Calculations!R15,\"\")","v":6},5.5]
[null,{"$f":"IF(Calculations!R16<'Feeding Curve'!$D$8+1,Calculations!R16,\"\")","v":7},6]
[null,{"$f":"IF(Calculations!R17<'Feeding Curve'!$D$8+1,Calculations!R17,\"\")","v":8},6.5]
[null,{"$f":"IF(Calculations!R18<'Feeding Curve'!$D$8+1,Calculations!R18,\"\")","v":9},7]
[null,{"$f":"IF(Calculations!R19<'Feeding Curve'!$D$8+1,Calculations!R19,\"\")","v":10},7.5]
[null,{"$f":"IF(Calculations!R20<'Feeding Curve'!$D$8+1,Calculations!R20,\"\")","v":11},8]
[null,{"$f":"IF(Calculations!R21<'Feeding Curve'!$D$8+1,Calculations!R21,\"\")","v":12},8.5]
[null,{"$f":"IF(Calculations!R22<'Feeding Curve'!$D$8+1,Calculations!R22,\"\")","v":13},9]
[null,{"$f":"IF(Calculations!R23<'Feeding Curve'!$D$8+1,Calculations!R23,\"\")","v":14},9.5]
[null,{"$f":"IF(Calculations!R24<'Feeding Curve'!$D$8+1,Calculations!R24,\"\")","v":15},10]
[null,{"$f":"IF(Calculations!R25<'Feeding Curve'!$D$8+1,Calculations!R25,\"\")","v":16},10.5]
[null,{"$f":"IF(Calculations!R26<'Feeding Curve'!$D$8+1,Calculations!R26,\"\")","v":17},10.5]
[null,{"$f":"IF(Calculations!R27<'Feeding Curve'!$D$8+1,Calculations!R27,\"\")","v":18},11]
[null,{"$f":"IF(Calculations!R28<'Feeding Curve'!$D$8+1,Calculations!R28,\"\")","v":19},11]
[null,{"$f":"IF(Calculations!R29<'Feeding Curve'!$D$8+1,Calculations!R29,\"\")","v":20},11.5]
[null,{"$f":"IF(Calculations!R30<'Feeding Curve'!$D$8+1,Calculations!R30,\"\")","v":21},11.5]
[null,{"$f":"IF(Calculations!R31<'Feeding Curve'!$D$8+1,Calculations!R31,\"\")","v":22},11.5]
[null,{"$f":"IF(Calculations!R32<'Feeding Curve'!$D$8+1,Calculations!R32,\"\")","v":23},11.5]
[null,{"$f":"IF(Calculations!R33<'Feeding Curve'!$D$8+1,Calculations!R33,\"\")","v":24},11.5]
[null,{"$f":"IF(Calculations!R34<'Feeding Curve'!$D$8+1,Calculations!R34,\"\")","v":25},11.5]
[null,{"$f":"IF(Calculations!R35<'Feeding Curve'!$D$8+1,Calculations!R35,\"\")","v":26},11.5]
[null,{"$f":"IF(Calculations!R36<'Feeding Curve'!$D$8+1,Calculations!R36,\"\")","v":27},11.5]
[null,{"$f":"IF(Calculations!R37<'Feeding Curve'!$D$8+1,Calculations!R37,\"\")","v":28},11.5]
[null,{"$f":"IF(Calculations!R38<'Feeding Curve'!$D$8+1,Calculations!R38,\"\")","v":29},11.5]
[null,{"$f":"IF(Calculations!R39<'Feeding Curve'!$D$8+1,Calculations!R39,\"\")","v":30},11.5]
[null,{"$f":"IF(Calculations!R40<'Feeding Curve'!$D$8+1,Calculations!R40,\"\")","v":31},11.5]
[null,{"$f":"IF(Calculations!R41<'Feeding Curve'!$D$8+1,Calculations!R41,\"\")","v":32},11.5]
[null,{"$f":"IF(Calculations!R42<'Feeding Curve'!$D$8+1,Calculations!R42,\"\")","v":33},11.5]
[null,{"$f":"IF(Calculations!R43<'Feeding Curve'!$D$8+1,Calculations!R43,\"\")","v":34},11.5]
[null,{"$f":"IF(Calculations!R44<'Feeding Curve'!$D$8+1,Calculations!R44,\"\")","v":35},11.5]
[]
[null,null,"Total Lactating Feed (kg)",{"$f":"SUMIFS(C11:C50,B11:B50,\">=\"&0,C11:C50,\"<=\"&D8)","v":327}]
[null,null,"Ave feed per day =",{"$f":"D52/D8","v":9.3428571428571434}]

{"sheet":"Calculations","index":4,"n_rows":64,"n_cols":18,"rows_kept":64,"cut":false,"hidden":true,"merged":[[48,2,48,3]]}
[]
[{"$f":"'Breeding Herd'!C26","v":"Feed costs"},{"$nulls":16},"Lactation curve"]
[{"$f":"'Breeding Herd'!C28","v":"Dry sow diet (£/t)"},{"$f":"'Breeding Herd'!E28","v":175}]
[{"$f":"'Breeding Herd'!C30","v":"Lactating sow diet (£/t)"},{"$f":"'Breeding Herd'!E30","v":220},{"$nulls":15},"Days"]
[{"$f":"'Breeding Herd'!C32","v":"Rebreeder diet (£/t)"},{"$f":"'Breeding Herd'!E32","v":200},{"$nulls":15},{"$f":"'Feeding Curve'!D6*-1","v":-4}]
[{"$f":"'Breeding Herd'!C34","v":"Creep feed (£/t)"},{"$f":"'Breeding Herd'!E34","v":1000},{"$nulls":15},{"$f":"R5+1","v":-3}]
[{"$nulls":17},{"$f":"R6+1","v":-2}]
["Litters per sow year",{"$f":"'Breeding Herd'!E40","v":2.2599999999999998},{"$nulls":15},-1]
["Piglets weaned per year",{"$f":"'Breeding Herd'!E10*'Breeding Herd'!E50","v":21485.322799999998},{"$nulls":15},0]
[{"$nulls":17},1]
[{"$f":"'Breeding Herd'!C54","v":"Dry sow diet (kg/day)"},{"$f":"'Breeding Herd'!E54","v":2.7},{"$nulls":15},2]
[{"$f":"'Breeding Herd'!C56","v":"Lactating sow diet (kg/day)"},{"$f":"'Breeding Herd'!E56","v":8.25},{"$nulls":15},3]
[{"$f":"'Breeding Herd'!C58","v":"Weaning to service (kg/day)"},{"$f":"'Breeding Herd'!E58","v":4},{"$nulls":15},4]
[{"$nulls":17},5]
[null,null,"Feed (t)","Feed (£)",{"$nulls":13},6]
["Pregnancy (days)",115,{"$nulls":15},7]
["Lactation (days)",{"$f":"'Breeding Herd'!E46","v":26},{"$nulls":15},8]
["Pregnancy (days per sow year)",{"$f":"B16*B8","v":259.89999999999998},{"$f":"B18*B11/1000","v":0.70172999999999996},{"$f":"B3*C18","v":122.80274999999999},{"$nulls":13},9]
["Lactation (days per sow year)",{"$f":"B17*B8","v":58.759999999999991},{"$f":"B19*B12/1000","v":0.48476999999999992},{"$f":"B4*C19","v":106.64939999999999},{"$nulls":13},10]
["Empty (days per sow year)",{"$f":"365-(B18+B19)","v":46.340000000000032},{"$f":"(B20*B13)/1000","v":0.18536000000000014},{"$f":"C20*B5","v":37.072000000000024},{"$nulls":13},11]
["Empty (days per litter)",{"$f":"B20/B8","v":20.504424778761077},{"$nulls":15},12]
[{"$nulls":17},13]
[{"$nulls":17},14]
[{"$f":"'Breeding Herd'!C63","v":"Sow feed usage (t/sow year)"},{"$f":"SUM(C18:C20)","v":1.3718600000000001},{"$nulls":15},15]
[{"$nulls":17},16]
["Sow feed cost (£/sow year)",{"$f":"SUM(D18:D20)","v":266.52414999999996},{"$nulls":15},17]
[{"$nulls":17},18]
[{"$nulls":17},19]
[{"$nulls":17},20]
["Herd size",{"$f":"'Breeding Herd'!E10","v":740},{"$nulls":15},21]
["Replacement Rate (%)",{"$f":"'Breeding Herd'!E14","v":55},{"$nulls":15},22]
["Sow mortality ( % )",{"$f":"'Breeding Herd'!E20","v":3},{"$nulls":15},{"$f":"R31+1","v":23}]
["Cull sows sold",{"$f":"(B35-(B35*B32/100))","v":394.79},{"$nulls":15},24]
["Cull sow income",{"$f":"B33*'Breeding Herd'!E22","v":51322.700000000004},{"$nulls":15},25]
["Net gilt requirement",{"$f":"B30*B31/100","v":407},{"$f":"B35","v":407},{"$nulls":14},26]
["Maiden Gilt Mortality (%)",{"$f":"'Gilt Rearing'!D17","v":0},{"$nulls":15},27]
["Gilts culled (%)",{"$f":"'Gilt Rearing'!D15","v":0},{"$nulls":15},28]
["Total losses (%)",{"$f":"B36+B37","v":0},{"$nulls":15},29]
["Total gilt requirement",{"$f":"B35+B40","v":407},{"$nulls":15},30]
["Total losses",{"$f":"(B38*B35)/(100-B38)","v":0},{"$nulls":15},31]
["Gilts on farm",{"$f":"'Gilt Rearing'!D13","v":0},{"$nulls":15},32]
["Total breeding females on farm",{"$f":"B30+B41","v":740},{"$nulls":15},33]
["Maiden Gilts as a percentage of total breeding herd",{"$f":"(B41/B42)*100","v":0},{"$nulls":15},34]
["Breeding herd total fixed and other variable costs (£/weaned piglet)",{"$f":"SUM('Breeding Herd'!I28:I50)","v":15.98},{"$f":"B44*$B$9","v":343335.45834399998},{"$nulls":14},35]
["Gilt rearing herd total fixed and other variable costs (£/weaned piglet)",{"$f":"B44*(B43/100)","v":0},{"$f":"B45*$B$9","v":0}]
["Sow herd total fixed and other variable costs (£/weaned piglet)",{"$f":"B44-B45","v":15.98},{"$f":"B46*$B$9","v":343335.45834399998}]
["Cull sow holding days pre sale ave 14","((sow herd x Rep%)-(sow herd x mort%))x14"]
[]
[null,"Days","Annual Gilt Flow",null,"Deaths","Culls","Feed (kg/gilt)","Feed cost (£/gilt)","Total feed cost (£)"]
[null,null,"IN","OUT"]
[null,{"$f":"'Gilt Rearing'!F36","v":0},{"$f":"B39","v":407},{"$f":"C51-(E51+F51)","v":407},{"$f":"$C$51*'Gilt Rearing'!O36/100","v":0},{"$f":"$B$39*'Gilt Rearing'!M36/100","v":0},{"$f":"'Gilt Rearing'!K36*'Gilt Rearing'!F36","v":0},{"$f":"G51/1000*'Gilt Rearing'!D36","v":0},{"$f":"H51*((C51+D51)/2)","v":0}]
[{"$f":"'Gilt Rearing'!C36","v":"Stage 1"},{"$f":"'Gilt Rearing'!F37","v":0},{"$f":"D51","v":407},{"$f":"C52-(E52+F52)","v":407},{"$f":"$C$51*'Gilt Rearing'!O37/100","v":0},{"$f":"$B$39*'Gilt Rearing'!M37/100","v":0},{"$f":"'Gilt Rearing'!K37*'Gilt Rearing'!F37","v":0},{"$f":"G52/1000*'Gilt Rearing'!D37","v":0},{"$f":"H52*((C52+D52)/2)","v":0}]
[{"$f":"'Gilt Rearing'!C37","v":"Stage 2"},{"$f":"'Gilt Rearing'!F38","v":0},{"$f":"D52","v":407},{"$f":"C53-(E53+F53)","v":407},{"$f":"$C$51*'Gilt Rearing'!O38/100","v":0},{"$f":"$B$39*'Gilt Rearing'!M38/100","v":0},{"$f":"'Gilt Rearing'!K38*'Gilt Rearing'!F38","v":0},{"$f":"G53/1000*'Gilt Rearing'!D38","v":0},0]
[{"$f":"'Gilt Rearing'!C38","v":"Stage 3"}]
[{"$nulls":4},{"$f":"SUM(E51:E54)","v":0},{"$f":"SUM(F51:F54)","v":0},0,0,0]
["Total",{"$f":"SUM(B51:B55)","v":0}]
[]
["Total annual gilt replacement costs (£)",{"$f":"'Gilt Rearing'!D49","v":36223}]
["Total annual gilt replacement costs (£/piglet weaned)",{"$f":"B58/B9","v":1.6859416233671856}]
[]
["Total annual AI costs (£)",{"$f":"'Breeding Herd'!E18","v":13472}]
[]
["Total annual cull sales (£)",{"$f":"'Breeding Herd'!E24","v":46348.346000000005}]
["Total annual cull sales (£/piglet weaned)",{"$f":"B63/B9","v":2.1572096650090828}]